CREATE VIEW [dbo].[v_clsAttDet2_dq]
AS
SELECT     dbo.CK_AttentionTab.CK_AttentionTabId, dbo.CK_AttentionTab.CK_SchoolTabID, dbo.CK_AttOtherClassTab.CK_AttOtherClassTabId, 
                      dbo.CK_SchoolTab.CK_SchoolTabName, dbo.CK_ClassTab.CK_ClassTabid, dbo.CK_ClassTab.CK_className, dbo.CK_CourseTab.CK_course, dbo.CK_TeacherTab.CK_TeacherName, 
                      dbo.CK_AttentionTab.classDate, dbo.CK_TimeSegTab.CK_ClassTime, dbo.CK_TimeSegTab.CK_DftHourQtty, dbo.CK_AttentionTab.clsAttMemo, 
                      dbo.CK_StudentInfo.CK_StudentInfoid,dbo.CK_StudentInfo.stdtName, dbo.CK_AttOtherClassTab.oIsStudy, dbo.CK_AttOtherClassTab.oIsDeductCT, dbo.CK_AttOtherClassTab.oAttDateTime, 
                      dbo.CK_AttOtherClassTab.detail2Memo
FROM         dbo.CK_AttentionTab INNER JOIN
                      dbo.CK_SchoolTab ON dbo.CK_SchoolTab.CK_SchoolTabID = dbo.CK_AttentionTab.CK_SchoolTabID INNER JOIN
                      dbo.CK_SchdDetail ON dbo.CK_SchdDetail.CK_SchdDetailId = dbo.CK_AttentionTab.CK_SchdDetailID INNER JOIN
                      dbo.CK_ClassTab ON dbo.CK_ClassTab.CK_ClassTabId = dbo.CK_SchdDetail.CK_ClassTabID INNER JOIN
                      dbo.CK_CourseTab ON dbo.CK_CourseTab.CK_CourseTabId = dbo.CK_SchdDetail.CK_CourseTabID INNER JOIN
                      dbo.CK_TeacherTab ON dbo.CK_TeacherTab.CK_TeacherTabID = dbo.CK_SchdDetail.CK_TeacherTabID INNER JOIN
                      dbo.CK_TimeSegTab ON dbo.CK_TimeSegTab.CK_TimeSegTabID = dbo.CK_SchdDetail.CK_TimeSegTabID INNER JOIN
                      dbo.CK_AttOtherClassTab ON dbo.CK_AttentionTab.CK_AttentionTabId = dbo.CK_AttOtherClassTab.CK_AttentionTabId INNER JOIN
                      dbo.CK_StudentInfo ON dbo.CK_AttOtherClassTab.CK_StudentInfoID = dbo.CK_StudentInfo.CK_StudentInfoID
